﻿--获得员工职务
CREATE proc [dbo].[proc_Employee_ZhiWu_GetItem]
(
	@id int
)
as

  --declare @pid int

  --select @pid=Pid from Employee_ZhiWu where Id=48
	select 
	Id,
	isnull(Pid,0) as Pid,
	Title
	--UpTime,
	--isnull((select Title from Employee_ZhiWu where Pid=@pid),'未知') as TypeTitle
	 from Employee_ZhiWu WHERE Id=@id
